QUERY DEF UTILITY (c) Copyright 1994 Winworks Software Corp. All Rights Reserved. Winworks Software Corporation P.O. Box 859 El Dorado, CA 95623-0859 USA CompuServe: 74211,2503 Internet: querydef@winworks.com Thanks for checking out this Query Def Utility for Access Databases. In an attempt to optimize my database searches, I looked for an easy way to create and edit Query Defs. I didn't find any so I wrote this little utility. In many cases, pre-compiling a Query Def into an Access MDB file will increase the speed of database searches. The BIBLIO.MDB file included with VB3 PRO uses several Query Defs and with the use of this program, you can view how they were set up. Installation ------------------------------------------------------------------ Only the program file and the vbx for the custom control are included to save space and modem time. You will need some VB3 PRO files to enable the utility. Specifically, you need the CMDIALOG.VBX, THREED.VBX, MSAES110.DLL, MSAJT110.DLL, VBDB300.DLL, and VBRUN300.DLL in your C:\WINDOWS\SYSTEM subdirectory. Query Defs can only be used with VB3 PRO. If you don't have it, it is worthwhile. To complete the installation, create a directory if you wish, and place in it the QueryDef.EXE file. Place the SSFORMFX.VBX in your C:\WINDOWS\SYSTEM subdirectory. You can then create an icon in your VB Applications group and your off and running. Use ------------------------------------------------------------------ This utility makes it painless to add, edit, view and delete compliled Query Defs within Access MDB files. Click Open Database and select an MDB file and click OK. If any Query Defs have been compiled into the MDB, you'll see a list of their names. To see the accompanying SQL statement, double-click on the Query Def in the list. Thats all there is to it. In your application code, access the query def by setting the recordsource property of a data control to the query def title, and the database name to the MDB file. (Data1.RecordSource="Query Def Title") or Set DS=DB.CreateDynaset("Query Def Title") or Set SS=DB.CreateShapShot("Query Def Title") once you have defined the DB. Shareware Registration ------------------------------------------------------------------ Try out this utility to see if you want to keep it. If you find that you use this utility after the trial period, and desire to keep it around, please cut a check for $10 to Winworks Software and send it along with your name, address and CompuServe ID to the address above. If this utility isn't helpful, just delete it. If you distribute it, this TXT file must accompany the program. This program is provided without any kind of express or implied warranty. Winworks Software Corp. will not be liable for any damages resulting from the use of or inability to use this utility. No telephone technical support is provided for this utility, however, suggestions, problems, and bug reports can be sent to the address above, or via EMAIL at the addresses above. Thanks. SSFORMFX.VBX (c) Copyright 1994 Sheridan Software Systems, Inc. All Rights Reserved. This VBX provided only as a component of the Query Def Utility. Any other use without express permission of Sheridan Software Systems, Inc. is prohibited.